package com.artPreter.mapper;

import com.artPreter.pojo.Depart;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 艺术机构表 Mapper 接口
 * </p>
 *
 * @author jarvis
 * @since 2024-11-14
 */
@Mapper
public interface DepartMapper extends BaseMapper<Depart> {

    @Select(" select s.* from jv_depart s left join jv_region b on b.id = s.region ${ew.customSqlSegment} ")
    List<Depart> getDepartListWithPid(@Param(Constants.WRAPPER) Wrapper wrapper);
}
